// 1-带有商品分类的商品表
const {DataTypes, db } = require("../db");
db.define('vGoods', {
id: {type: DataTypes.INTEGER, primaryKey: true, autoIncrement: true,comment:'表自增ID'},
tenantId:{type: DataTypes.INTEGER,allowNull:false,comment:''}, 
categoryId:{type: DataTypes.SMALLINT,comment:''}, 
goodCatCode:{type: DataTypes.STRING(255),comment:''}, 
brandId:{type: DataTypes.INTEGER,comment:''}, 
goodCatName:{type: DataTypes.STRING(255),comment:''}, 
categoryName:{type: DataTypes.STRING(255),comment:''}, 
name:{type: DataTypes.STRING(150),allowNull:false,comment:''}, 
code:{type: DataTypes.STRING(50),comment:''}, 
spec:{type: DataTypes.INTEGER,allowNull:false,comment:''}, 
barCode:{type: DataTypes.STRING(60),comment:''}, 
barCode1:{type: DataTypes.STRING(60),comment:''}, 
unit1Id:{type: DataTypes.INTEGER,allowNull:false,comment:''}, 
unit2Id:{type: DataTypes.INTEGER,comment:''}, 
unit1:{type: DataTypes.STRING(50),comment:''}, 
unit2:{type: DataTypes.STRING(50),allowNull:false,comment:''}, 
baseUnit:{type: DataTypes.STRING(50),comment:''}, 
vol:{type: DataTypes.DECIMAL(18, 2),comment:''}, 
price1:{type: DataTypes.DECIMAL(18, 2),comment:''}, 
price2:{type: DataTypes.DECIMAL(18, 2),comment:''}, 
lowQty:{type: DataTypes.DECIMAL(18, 2),comment:''}, 
highQty:{type: DataTypes.DECIMAL(18, 2),comment:''}, 
length:{type: DataTypes.INTEGER,comment:''}, 
width:{type: DataTypes.INTEGER,comment:''}, 
sendPrice:{type: DataTypes.DECIMAL(18, 2),comment:''}, 
height:{type: DataTypes.INTEGER,comment:''}, 
weight:{type: DataTypes.DECIMAL(18, 2),comment:''}, 
wrapperId:{type: DataTypes.INTEGER,comment:''}, 
pinYin:{type: DataTypes.STRING(100),comment:''}, 
safeDays:{type: DataTypes.INTEGER,comment:''},
imgUrl:{type: DataTypes.STRING(255),comment:''}, 
cby:{type: DataTypes.INTEGER,comment:''}, 
ctime:{type: DataTypes.STRING(20),comment:''}, 
uby:{type: DataTypes.INTEGER,comment:''}, 
utime:{type: DataTypes.STRING(20),comment:''}, 
dby:{type: DataTypes.INTEGER,comment:''}, 
dtime:{type: DataTypes.STRING(20),comment:''}, 
isDel:{type: DataTypes.INTEGER,comment:''}, 
hjId:{type: DataTypes.INTEGER,comment:''}, 
hjName:{type: DataTypes.STRING(255),comment:''}, 
brandName:{type: DataTypes.STRING(150),comment:''}, 
searchTxt:{type: DataTypes.STRING(406),allowNull:false,comment:''}, 

}, {
    tableName: 'v_goods',
    timestamps: false,
    comment: '1-带有商品分类的商品表',
    
});